package com.neusoft.elm.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.neusoft.elm.dao.AdminDao;
import com.neusoft.elm.po.Admin;
import com.neusoft.elm.util.DBUtil;

public class AdminDaoImpl implements AdminDao {

	private Connection con = null;
	private PreparedStatement pst = null;
	private ResultSet rs = null;

	public Admin getAdminByNameByPassword(String adminName, String password) {
		Admin admin = null;
		String sql = "select * from admin where adminName=? and password=?";
			try {
				con = DBUtil.getConnection();
				pst = con.prepareStatement(sql);
				pst.setString(1,adminName);
				pst.setString(2,password);
				rs = pst.executeQuery();
				while(rs.next()) {
					admin = new Admin();
					admin.setAdminId(rs.getInt("adminId"));
					admin.setAdminName(rs.getString("adminName"));
					admin.setPassword(rs.getString("password"));
				}
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				DBUtil.close(rs,pst,con);
			}
		
		return admin;
	}

}
